Elevate Software Blog

Showing all blog entries tagged with "New Releases"

DBISAM 4.48 Released

Posted by Tim Young on Mon, Feb 25 2019

DBISAM 4.48 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

The new features are below:

New 4.48 Features

The following are the new features in 4.48:

There are new TDBISAMEngine RecordLockTrigger and RecordUnlockTrigger events that are fired for every record lock or unlock operation. This is useful for tracking record locks or diagnosing locking issues.

Tags: DBISAM, New Releases

Permanent Link • 0 Comments

ElevateDB 2.30 Released with RAD Studio 10.3 Rio Support

Posted by Tim Young on Sat, Jan 5 2019

ElevateDB 2.30 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

The breaking changes and new features for the ElevateDB VCL/LCL, DAC, and PHP products are below. In addition, this release contains several bug fixes, which are detailed here.

2.30 Breaking Changes

The following are breaking changes in 2.30:

The ElevateDB Server no longer shows a user interface when installed and run as a Windows service. In conjunction with this change, the No User Interface edbsrvr.ini setting is no longer used.

2.30 New Features

ElevateDB 2.30 now includes support for Embarcadero RAD Studio 10.3 Rio (Delphi 10.3 32/64-bit, and C++Builder 10.3 32/64-bit).

The following are the new features in 2.30:

The migrator performance has been improved quite a bit by switching from an architecture based upon explicit INSERT statements to one based upon parameterized INSERT statements combined with binary parameter handling. Previously, large tables that contained large BLOB columns would take an inordinate amount of time to completely migrate, and that amount of time has been drastically reduced.

Tags: ElevateDB, New Releases

Permanent Link • 0 Comments

DBISAM 4.47 Released

Posted by Tim Young on Wed, Dec 26 2018

DBISAM 4.47 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

The breaking changes and new features are below:

4.47 Breaking Changes

The DBISAM Database Server no longer shows a user interface when installed and run as a Windows service. In conjunction with this change, the /NI command-line parameter is no longer used and the No User Interface dbsrvr.ini setting is no longer used.

4.47 New Features

DBISAM 4.47 now includes support for Embarcadero RAD Studio 10.3 Rio (Delphi 10.3 32/64-bit, and C++Builder 10.3 32/64-bit).

Tags: DBISAM, New Releases

Permanent Link • 0 Comments

DBISAM 4.46 Released

Posted by Tim Young on Thu, Nov 29 2018

DBISAM 4.46 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

The breaking changes and new features for both the DBISAM VCL and ODBC products are below.

4.46 New Features

The following are the new features in 4.46:

The join execution performance has been improved, and you should see an overall decrease in execution times for SQL statements that include joins.

The DBISAM Database Servers that are shipped with DBISAM now include the ability to use SQL performance tracking/logging to detect SQL statements that are exhibiting bad performance. This capability is a server-level feature, and is not implemented in the TDBISAMEngine component (it uses the SQL execution trigger in the engine). You can find out more information on the various dbsrvr.ini file options for the SQL performance tracking/logging here:

Configuring and Starting the Server

under the section that shows a sample dbsrvr.ini file (Sample DBISAM Database Server Parameters INI File).

Tags: DBISAM, New Releases

Permanent Link • 0 Comments

ElevateDB 2.29 Released with 32-bit MacOS Support

Posted by Tim Young on Mon, Nov 26 2018

ElevateDB 2.29 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

The breaking changes and new features for the ElevateDB VCL/LCL, DAC, and PHP products are below. In addition, this release contains several bug fixes, which are detailed here.

2.29 Breaking Changes

The following are breaking changes in 2.29:

The MIGRATE DATABASE statement now disables all default column value assignments when migrating table rows. The migration functionality uses INSERT statements to migrate rows from the source database to the target database. Previously, the default column value assignments could cause primary and unique key conflicts when columns containing NULL values were migrated to the new database.

The lightweight word generator module, text filter module, and external module templates have been changed so that only module-relevant code is required in the actual project, and all ElevateDB module-specific code is part of engine-level units, similarly to the non-lightweight modules. The following is the implementation code for the new lightweight external module template project's main unit (Unit1):

implementation

procedure TEDBLightweightExternalModule1.DoRoutine(const RoutineName: String);
begin
   { Fill in the routine (function or procedure) execution code here.
     You can have multiple functions and/or procedures in a module.
     Use the RoutineName parameter to determine which function or
     procedure is being executed.  Use the public ParamValues property of
     this external module (TEDBParamValues object) to access the parameters to
     the function or procedure.  Do not modify the ParamValues property other
     than to get/set the parameter values or Null flag.  Adding, removing,
     or changing the data type or parameter type of a parameter can cause
     serious problems.

     NOTE: The TEDBParamValues class is an internal ElevateDB engine class,
     and is used instead of the normal TParams class to bypass the inclusion
     of the Delphi VCL/DB units that cause the DLL size to bloat.  You can find
     out the various properties and methods available for this class in the
     edbvalue.pas and edbparam.pas units for ElevateDB.  If you are not
     comfortable working with an internal class such as this that contains no
     documentation, then you should use the normal external module template
     project that is installed into the Delphi object repository }
end;

initialization
   {  You *must* set the external module class, otherwise your class
      will not get instantiated !!! }
   LightweightExternalModuleClass:=TEDBLightweightExternalModule1;
end.

The key is the use of the initialization section to assign the class type for all lightweight modules that are instantiated by ElevateDB for this lightweight module.

For both the normal and lightweight word generator, text filter, and external module template projects, the exports clause has been moved from the .dpr (project file) to the main unit for the template projects. This change was required due to the Delphi MacOS compiler requirement that any library exports clauses not appear in the project files. You will need to make sure to adjust any existing word generator, text filter, and external module projects accordingly if you plan on using them with the MacOS version of ElevateDB.

2.29 New Features

The following are the new features in 2.29:

ElevateDB now supports the 32-bit MacOS compiler for RAD Studio XE4 and higher. RAD Studio XE2 and XE3 lack some necessary platform APIs, so support for those compilers will not be possible.

ElevateDB now includes SQL statement performance logging that can be used for determining which SQL statements are taking the longest to execute. There are new ENABLE STATEMENT LOGGING and DISABLE STATEMENT LOGGING statements, along with a new LoggedStatements Table system information table for reviewing which statements have been logged.

The PUBLISH DATABASE statement now includes a new BY clause that allows you to specify how you want the updates for a given table or tables to be logged.

The MIGRATE DATABASE statement now includes a new START AT TABLE clause that allows you to specify the table at which the migration should start. This is useful when the migration of a large database fails for an unexpected reason, and you don't want to start the migration from the first table in the database again.

The LOAD UPDATES statement now includes new MERGE DUPLICATE INSERTS and INSERT MISSING UPDATES clauses which allow for further control over how primary key constraints are handled during the loading of updates.

There are new ENABLE DEFAULTS, DISABLE DEFAULTS, ENABLE GENERATED, and DISABLE GENERATED statements that allow you to selectively enable/disable the default column value and generated column value functionality, respectively, in ElevateDB.

The join performance in ElevateDB has been improved, especially for SELECT statements that include joins performing lookups. Such joins tend to include lots of repeating driver table values, and ElevateDB uses this information to cache prior join projection sets and avoid re-building them.

There are new SET STATEMENT CACHE and SET PROCEDURE CACHE statements for setting the statement and function/procedure cache sizes for jobs.

Tags: ElevateDB, New Releases

Permanent Link • 0 Comments

ElevateDB 2.28 Released

Posted by Tim Young on Wed, May 2 2018

ElevateDB 2.28 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

The breaking changes and new features for the ElevateDB VCL/LCL, DAC, and PHP products are below. In addition, this release contains several bug fixes, which are detailed here.

2.28 Breaking Changes for VCL/LCL Products

The following are breaking changes in 2.28:

Large file support is now enabled by default in ElevateDB. Along with this change, the TEDBEngine LargeFileSupport and TEDBSession LocalLargeFileSupport properties have been removed.

These are published properties, so please be sure to open, ignore any warnings about these properties being absent, and re-save any forms or data modules that use the TEDBEngine or TEDBSession components to ensure that you do not see any runtime missing property errors in your application(s).

If you are using local ElevateDB sessions to directly access shared databases on a file server, you need to make sure that all client applications that are accessing the data are either updated to 2.28 or have their pre-2.28 TDBISAMEngine LargeFileSupport and/or LocalLargeFileSupport properties set to True. Failure to do so can cause the local ElevateDB sessions to not see each other's locks, which can lead to database corruption.

The TEDBEngine ExclusiveFileAccess property has been removed and replaced with the TEDBEngine BufferedFileIO property. Please see the new features in 2.28 section below for more information on the new buffered file I/O functionality in ElevateDB.

2.28 New Features for VCL/LCL Products

The following are the new features in 2.28:

ElevateDB now includes new global buffered file I/O functionality. There are new TEDBEngine BufferedFileIO, BufferedFileIOSettings, and BufferedFileIOFlushInterval properties for configuring the buffered file I/O in the engine. Please see the Buffering and Caching topic in the SQL manual for more information.

ElevateDB now includes new SQL statement and function/procedure caching functionality. There are new TEDBSession SQLStmtCacheSize and FuncProcCacheSize properties for configuring the caching, as well as the TEDBSession FreeCachedSQLStmts and FreeCachedFuncProcs methods for freeing cached SQL statements and functions/procedures. Please see the Buffering and Caching topic in the SQL manual for more information.

There are two new system information tables, the FileIOStatistics table, and the SessionStatistics Table table.

There is a new CURRENT_SESSIONID function for returning the current session ID in SQL/PSM routines.

2.28 Breaking Changes for DAC Products

The following are breaking changes in 2.28:

Large file support is now enabled by default in ElevateDB. Along with this change, the LARGEFILESUPPORT connection attribute has been removed.

If you are using local ElevateDB sessions to directly access shared databases on a file server, you need to make sure that all client applications that are accessing the data are either updated to 2.28 or have their pre-2.28 LARGEFILESUPPORT connection attributes set to True. Failure to do so can cause the local ElevateDB sessions to not see each other's locks, which can lead to database corruption.

2.28 New Features for DAC Products

The following are the new features in 2.28:

ElevateDB now includes new global buffered file I/O functionality. Please see the Buffering and Caching topic in the SQL manual for more information.

ElevateDB now includes new SQL statement and function/procedure caching functionality. There are new STMTCACHESIZE and PROCCACHESIZE connection attributes for configuring the caching, as well as the EDBConnection FreeCachedStatements and FreeCachedProcedures methods for freeing cached SQL statements and functions/procedures in the ElevateDB .NET Data Provider (there are no equivalents for the ElevateDB ODBC Driver. Please see the Buffering and Caching topic in the SQL manual for more information.

There are two new system information tables, the FileIOStatistics table, and the SessionStatistics Table table.

There is a new CURRENT_SESSIONID function for returning the current session ID in SQL/PSM routines.

2.28 Breaking Changes for PHP Products

The following are breaking changes in 2.28:

Large file support is now enabled by default in ElevateDB. Along with this change, the LARGEFILESUPPORT connection attribute has been removed.

If you are using local ElevateDB sessions to directly access shared databases on a file server, you need to make sure that all client applications that are accessing the data are either updated to 2.28 or have their pre-2.28 LARGEFILESUPPORT connection attributes set to True. Failure to do so can cause the local ElevateDB sessions to not see each other's locks, which can lead to database corruption.

2.28 New Features for PHP Products

The following are the new features in 2.28:

ElevateDB now includes new global buffered file I/O functionality. Please see the Buffering and Caching topic in the SQL manual for more information.

ElevateDB now includes new SQL statement and function/procedure caching functionality. There are new STMTCACHESIZE and PROCCACHESIZE connection attributes for configuring the caching, as well as the edb_freecachedstmts and edb_freecachedprocs functions for freeing cached SQL statements and functions/procedures. Please see the Buffering and Caching topic in the SQL manual for more information.

There are two new system information tables, the FileIOStatistics table, and the SessionStatistics Table table.

There is a new CURRENT_SESSIONID function for returning the current session ID in SQL/PSM routines.

Tags: ElevateDB, New Releases

Permanent Link • 0 Comments

Previous Entries: 1-6 7-12 13-18 19-24 25-30 31-36 37-42 43-48 49-54 55-60 61-66 67-72

RSS Feeds

RSS 2.0 Feed